[dbo].[BAESetConfigurationVariable]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAESetConfigurationVariable

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@pVariable	varchar(256)	256
@pCurrentValue	varchar(4096)	4096

SQL Script

create procedure [dbo].[BAESetConfigurationVariable] @pVariable as
varchar(256),
    @pCurrentValue AS varchar(4096)
AS
    UPDATE Configuration
    SET Configuration.CurrentValue = @pCurrentValue
    WHERE Configuration.Variable = @pVariable;

GO

Uses